FO_UserLocations
UserLocations table provides a place to define general location information and assign default EPM process codes.
| Field | Type | Notes |
|---|---|---|
|
UserLoc_ID |
int |
ID field, a counter. Unique |
|
UserLocationCode |
varchar(50) |
Arbitrary location code referenced as part of user sign on. Enter a valid location code. (is it really arbitrary?) |
|
UserLocationName |
varchar(80) |
Name of user location. |
|
GroupCode |
varchar(50) |
Multiple user locations can be grouped together to minimize maintenance. This provides an informational cross reference. See theFO_UserLoc_Groups table. (is this a pipe delimited set of location codes?) |
|
DeviceLocationCodes |
varchar(255) |
Device locations associated with this user location. Informational. (is this a pipe delimited set of codes? what kind of codes? |
|
Add1 |
varchar(50) |
First address line. Informational |
|
Add2 |
varchar(50) |
Second address line. Informational |
|
City |
varchar(50) |
City. Informational |
|
St |
varchar(50) |
State. Informational |
|
ZipCode |
varchar(50) |
Zip code. Informational |
|
Tel |
varchar(50) |
Phone number. Informational |
|
Fax |
varchar(50) |
Fax number. Informational |
|
ContactName |
varchar(50) |
Contact name. Informational |
|
Manager |
varchar(50) |
Manager. Informational |
|
CreateDate |
datetime |
Date record was created. Informational |
|
EditDate |
datetime |
Date record was edited. Informational |
|
UserName |
varchar(50) |
User who created the record. Informational |
|
DefPerfLab |
varchar(50) |
Default performing lab for this user location. Enter a valid performing lab code. Impacts Auto Receipt process. Displays as Def Receipt Perf.Lab on FAST header. If calculated performing lab equals Def Receipt Perf.Lab, then order is eligible for auto receipt. (is Def Receipt Perf.Lab the correct was to represent that field or label or whatever it is? |
|
CallResolutionCode |
int |
Default value for EPM CALL records created in FAST. Enter a valid code which comes from EPM definitions, RRE_ExceptionResolutionGroupCode_Definition. |
|
StatResolutionCode |
int |
Default value for EPM STAT records created in FAST. Enter a valid code which comes from EPM definitions, RRE_ExceptionResolutionGroupCode_Definition. |
|
CriticalResolutionCode |
int |
Default value for EPM Critical records created in FAST. Enter a valid code which comes from EPM definitions, RRE_ExceptionResolutionGroupCode_Definition. |
|
SignificantResolutionCode |
int |
Default value for EPM Significant Findings records created in FAST. Enter a valid code which comes from EPM definitions, RRE_ExceptionResolutionGroupCode_Definition. |
|
PatientResolutionCode |
int |
Default value for EPM Patient records created in FAST. Enter a valid code which comes from EPM definitions, RRE_ExceptionResolutionGroupCode_Definition. |
|
OrderResolutionCode |
int |
Default value for EPM Order records created in FAST. Enter a valid code which comes from EPM definitions, RRE_ExceptionResolutionGroupCode_Definition. |
|
SpecimenResolutionCode |
int |
Default value for EPM Specimen records created in FAST. Enter a valid code which comes from EPM definitions, RRE_ExceptionResolutionGroupCode_Definition. |
|
DefaultResolutionCode |
int |
Default value for EPM records created in FASTthat are not otherwise defined. Enter a valid code which comes from EPM definitions, RRE_ExceptionResolutionGroupCode_Definition. |
|
ReportResolutionCode |
int |
Default value for EPM Report records created in FAST. Enter a valid code which comes from EPM definitions, RRE_ExceptionResolutionGroupCode_Definition. |
|
ClientRequestResolutionCode |
int |
Default value for EPM Client Request records created in FAST. Enter a valid code which comes from EPM definitions, RRE_ExceptionResolutionGroupCode_Definition. |
|
CollectionHUBCodes |
varchar(MAX) |
Valid Collection HUB codess (this data type implies the expectation of a very large string, of collection hub codes. Is it a pipe-delimited list? where is the maintenance table for collection hub codes?, is that the FO_Hub_Definition table?) |
|
DefaultWorkFlowMethod |
varchar(50) |
Default Workflow for users logged into this user location. Enter an allowed value. Allowed values: PATIENT SPECIMEN INDUSTRIAL If field is null, or blank, the default is PATIENT. FO_UserLocations definition is referenced if the user-level definition is NULL. |
|
LabCode |
varchar(50) |
Default lab code associated with this user location. Enter a valid lab code from FO_LabInfo.LabCode values. |
|
WarnCollectDateOlderDays |
int |
Represents the number of days past which a warning message that collection date is X days in the past will be displayed. Enter an integer for the number of days. |